| Welcome to WebmasterWorld Guest from 18.104.22.168 |
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
|Pubcon Platinum Sponsor 2014|
|Explode MySql Records|
Is there a way to explode mySQL records / values while searching for records
example : SELECT * FROM tablename WHERE field = 'explode("-",field')...
I cant use the operator LIKE because the field can have records like
If I want to search for records with 10, it should only return the 1st and 3rd record.
Not that I know of. Can you use regular expressions? You should be able to substitute like for regexp though . . .
$some_var = '10';
select * from tablename where field regexp '.*$some_var.*';
select * from tablename where field regexp '.*\-$some_var\-.*';
Might have to do an "or" if it's potentially a leading or trailing:
select * from tablename where field regexp '.*\-$some_var\-.*' or field regexp '$some_var\-.*' or field regexp '.*\-$some_var';
you can also try instr() [dev.mysql.com]:
select * from tablename where instr(field,'$some_var');
Though that will match on 100 . . .
RLIKE. It is LIKE but with regexp.
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved