CODEWITHSUNDEEP
mysqlsql-like
coolguy
coolguy

Reputation: 7954

mysql like issue on partial match

Im having a mysql query like this

SELECT group_name FROM t_groups WHERE group_name LIKE '%PCB%';

The results are

group_name
------------
PCB
Full size PCB

Another query,

SELECT group_name FROM t_groups WHERE group_name LIKE '%PCB-123%';

group_name
-----------
PCB-123

How can i use a query that will show all the three results ?,I mean i need to get all the results that starts or contains PCB

Upvotes: 0

Views: 9680

Answers (3)

solaimuruganv
solaimuruganv

Reputation: 29697

 SELECT group_name FROM test WHERE group_name LIKE '%PCB%'

this is working fine in mysql , check fiddle demo

Upvotes: 2

Shabarinath Volam
Shabarinath Volam

Reputation: 745

I have executed your query

SELECT group_name FROM t_groups WHERE group_name LIKE '%PCB%';

Works fine for me . It returned 3 records

Can you explain what type of datatype you have used for group_name column

Upvotes: 1

xkeshav
xkeshav

Reputation: 54016

use RLIKE

as you have changed the context of your question so below is my updated answer

SELECT group_name FROM t_groups WHERE group_name RLIKE '[PCB]'

Upvotes: 5

Related Questions