Regular expression matching in mysql instead of like

Question

My previous question seems to be unclear.so im putting a new question with more clear data

The query

SELECT * FROM t_groups WHERE group_name LIKE '%pla%'

The results

enter image description here

MY question is when user search for something like 'plablablabla',How can i show all the results in the above image..i tried LIKE and RLIKE and im not good with regular expressions..any help is highly appreciated

DiverseAndRemote.com · Accepted Answer · 2012-10-16 05:51:24Z

1

you need the mysql regexp keyword. More info at http://dev.mysql.com/doc/refman/5.1/en/regexp.html

answered Oct 16, 2012 at 5:51

DiverseAndRemote.com

20k10 gold badges65 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

John Woo · Accepted Answer · 2012-10-16 05:51:49Z

0

SELECT * 
FROM t_groups 
WHERE group_name REGEXP 'pla'

answered Oct 16, 2012 at 5:51

John Woo

265k70 gold badges509 silver badges500 bronze badges

3 Comments

coolguy Over a year ago

empty results when i searched SELECT * FROM t_groups WHERE group_name REGEXP 'plablablaaa';

John Woo Over a year ago

because plablablaaa is not contained on the list above. so you want to search for plablablaaa but still display Plain? how is that possible.

coolguy Over a year ago

Because Plain and plablabla both starts with 'pla'..anyway to do with regular expression ?

Collectives™ on Stack Overflow

Regular expression matching in mysql instead of like

2 Answers 2

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related