how can i search data in php using explode by sql query?

Question

My database has row with a column like

data1+data2+data3+data4

How can i search specific value by sql query in php?

For example data2?

The +s separate each data point.

I can't work out what you are asking, are you asking for information on how you can split a string returned from a MySQL query using the preg_split function? — Professor of programming, Sep 14 '15 at 12:42
It might be easier just to include some code so we can try and work out what you are asking. — Professor of programming, Sep 14 '15 at 12:42
Right so you have a query, do you run it or are you wanting to split the `$_GET['searchtext']` string? — Professor of programming, Sep 14 '15 at 12:44
`$_GET['searchtext']` and `` don't match so you will always end up with an empty string. — Professor of programming, Sep 14 '15 at 12:45
Are you using `+`s in your DB as delimiters and you now want to be able to search by the individual values? — chris85, Sep 14 '15 at 12:46
You need to normalize your db. It should be one row per value. — chris85, Sep 14 '15 at 12:47
@RamnikRangpariya please read http://stackoverflow.com/help/how-to-ask — Professor of programming, Sep 14 '15 at 12:50
I've reformatted your question I think to be clearer, if not please revert it. — chris85, Sep 14 '15 at 12:50
in sql table, fieldname = "data1+data2+data3+data4" .i want to be able to search by the individual values using sql query — Ramnik Rangpariya, Sep 14 '15 at 13:00
See this thread http://stackoverflow.com/questions/3653462/is-storing-a-delimited-list-in-a-database-column-really-that-bad. — chris85, Sep 14 '15 at 13:11

score 0 · Answer 1 · edited Jul 26 '21 at 05:27

0

Why don't you try something like below:

SELECT   (data1+data2+data3+data4) AS total 
FROM     Table
WHERE    total LIKE '%YOUR_QUERY%'

Now you can use the index total

edited Jul 26 '21 at 05:27

Asef Hossini

655
8
11

answered Sep 14 '15 at 12:46

Malay M

1,659
1
14
22

score 0 · Accepted Answer · edited Jul 26 '21 at 16:59

0

$lcSearchVal = "data1+data2+data3+data4";
$lcSearchVal = explode( '+', $lcSearchVal );

$sql = 'SELECT * FROM tablename WHERE (';

$data_array = array();
foreach( $lcSearchVal as $lcSearchWord )
{ 
    $data_array[] = 'fieldname LIKE "%'.$lcSearchWord.'%"'; 
}

$sql .= implode(' OR ', $data_array).')';

print $sql;

edited Jul 26 '21 at 16:59

Asef Hossini

655
8
11

answered Sep 15 '15 at 08:59

Ramnik Rangpariya

1
7

how can i search data in php using explode by sql query?

2 Answers2