mysql select query within a serialized array

by

As GWW says in the comments, if you need to query things this way, you really ought to be considering storing this data as something other than a big-ole-string (which is what your serialized array is).

If that’s not possible (or you’re just lazy), you can use the fact that the serialized array is just a big-ole-string, and figure out a LIKE clause to find matching records. The way PHP serializes data is pretty easy to figure out (hint: those numbers indicate lengths of things).

Now, if your serialized array is fairly complex, this will break down fast. But if it’s a flat array, you should be able to do it.

Of course, you’ll be using LIKE ‘%…%’, so you’ll get no help from any indicies, and performance will be very poor.

Which is why folks are suggesting you store that data in some normalized fashion, if you need to query “inside” it.

More Related Contents:

  1. Sign in form always showing "Wrong Credentials"
  2. Prevent creating duplicate entries in PHP
  3. i have stored array in database as a string how can retrieve that array?
  4. Insert array into MySQL database with PHP
  5. Sum values of multidimensional array by key without loop
  6. I have an array of integers, how do I use each one in a mysql query (in php)? [duplicate]
  7. Save PHP array to MySQL?
  8. Notice: Array to string conversion in
  9. mysql_fetch_array, mysql_fetch_assoc, mysql_fetch_object
  10. How get all values in a column using PHP?
  11. PDO fetch one column from table into 1-dimensional array
  12. Get all mysql selected rows into an array
  13. Select from mysql table WHERE field=’$array’?
  14. MySQL query using an array [duplicate]
  15. How to insert json array into mysql database
  16. Why do I get “Resource id #4” when I apply print_r() to an array in PHP? [duplicate]
  17. PHP/SQL Insert Error when using Named Placeholders
  18. Create PHP array from MySQL column
  19. Save array in mysql database
  20. MySQL PHP – SELECT WHERE id = array()? [duplicate]
  21. Find a matching or closest value in an array
  22. Why is using a mysql prepared statement more secure than using the common escape functions?
  23. localhost vs. 127.0.0.1 in mysql_connect()
  24. Shorthand for arrays: is there a literal syntax like {} or []?
  25. PHP – Find parent key of array
  26. Warning: array_combine(): Both parameters should have an equal number of elements
  27. PDO MySQL: Insert multiple rows in one query
  28. How to force Doctrine to update array type fields?
  29. Push item to associative array in PHP
  30. Implementing a simple lookup array

Leave a Comment