mysql like issue on partial match
Posted
by
ubercooluk
on Stack Overflow
See other posts from Stack Overflow
or by ubercooluk
Published on 2012-10-16T04:51:31Z
Indexed on
2012/10/16
5:02 UTC
Read the original article
Hit count: 72
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
© Stack Overflow or respective owner
