How do i search from serialize field in mysql database?

by

Have you tried the following:

SELECT * FROM table WHERE field like '%"m9";s:18:"Ok Then, Yes It Is";%'

?

But in fact if you want to search in such data, you should simple create proper structure of your table and not to put all serialized data in one column

More Related Contents:

  1. Order results from two queries based on time in second query [closed]
  2. Query database then email posts from where user is subbed to
  3. Using PHP data in MySQL [closed]
  4. Save the data into a database and return another value from database using PHP
  5. Checking the availability of rooms
  6. How can I do ‘insert if not exists’ in MySQL?
  7. How to properly set up a PDO connection
  8. Getting raw SQL query string from PDO prepared statements
  9. How to repair a serialized string which has been corrupted by an incorrect byte count length?
  10. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  11. MySQL Prepared statements with a variable size variable list
  12. Loading .sql files from within PHP
  13. PDO with INSERT INTO through prepared statements [closed]
  14. SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102 [closed]
  15. MySQL “NOT IN” query 3 tables
  16. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  17. PHP: multiple SQL queries in one mysql_query statement
  18. Doing a while / loop to get 10 random results
  19. PHP – Import CSV file to mysql database Using LOAD DATA INFILE
  20. Why does this return Resource id #2? [duplicate]
  21. Simple PHP SQL login troubleshooting
  22. Change date format (in DB or output) to dd/mm/yyyy – PHP MySQL
  23. MySql PHP select count of distinct values from comma separated data (tags)
  24. How to SELECT DEFAULT value of a field
  25. Laravel Eloquent get results grouped by days
  26. JSON vs. Serialized Array in database [closed]
  27. Do I have to use mysql_real_escape_string if I bind parameters?
  28. SELECT row by DATEPART()
  29. UNION syntax in Cakephp
  30. PDO and MySQL ‘between’

Leave a Comment