PHP: How to search a cell if the word in it has a prefix?
- Thread starter Jangga
- Start date
- Nov 29, 2012
- 46,012
- 13,844
Jangga
Junior Member
- Aug 8, 2016
- 196
- 11
Thanks, but
I don't know how to use it in a select query
mysql_query("select * from travis where citi='preg_match(condition here)'");
That won't work. Please, help
handmadebots
Senior Member
- Nov 8, 2012
- 1,072
- 255
select * from travis where citi='fixed_prefix%'
select * from travis where citi='new%'
select * from travis where citi='%fixed_subfix'
select * from travis where citi='%york'
select * from travis where citi='%fixed_middle_string%'
select * from travis where citi='%gor%'
select * from travis where citi='new%'
select * from travis where citi='%fixed_subfix'
select * from travis where citi='%york'
select * from travis where citi='%fixed_middle_string%'
select * from travis where citi='%gor%'
- Nov 29, 2012
- 46,012
- 13,844
Ahh, I thought you meant array data... my bad. Not had my Red Bull yet...
You can do it in two steps, first get the data with a query like this:
o hai = the prefix.
From this data then create a function with a for each loop and a preg_match to go through the returned results and find what you're looking for.
You can do it in two steps, first get the data with a query like this:
Code:
SELECT * from TableName Where ColumnName LIKE 'o hai%'o hai = the prefix.
From this data then create a function with a for each loop and a preg_match to go through the returned results and find what you're looking for.
Jangga
Junior Member
- Aug 8, 2016
- 196
- 11
Since I want to select with two conditions will it work with and clause? E.G
select * from travis where user='$user' and citi='fixed_prefix%'
Please answer. Thanks in advance
Jangga
Junior Member
- Aug 8, 2016
- 196
- 11
Since I want to select with two conditions will it work wwith AND clause? E.G
Code:
SELECT * from TableName Where ColumnName1='$user' AND ColumnName2 LIKE 'o hai%'Thanks in advance
Jangga
Junior Member
- Aug 8, 2016
- 196
- 11
Thanks man