SQL Query with binary data (PHP and MySQL)

by

Note: This addresses binary data, but not encrypted data. See this answer for searching on encrypted data.

Try adding X, x or 0x in front of binary data used for search:

SELECT id FROM test WHERE pid = '0xÞFÈ>ZPÎ×jRZ{æ×';

EDIT: try also this:

SELECT id FROM test WHERE BINARY pid = 'ÞFÈ>ZPÎ×jRZ{æ×';

OR

SELECT id FROM test WHERE HEX(pid) = BIN2HEX('0xÞFÈ>ZPÎ×jRZ{æ×');

as supposed here: How to select with a binary field ? (php,mysql)

IF NOTHING FROM ABOVE WORKS: Try obtaining the pid in HEX format, like

SELECT id, HEX(pid) pid, test FROM test

and then when searching try only:

SELECT id, test FROM test WHERE HEX(pid) = '{$my_pid}'

But I’m not sure how do You obtain the pid data to PHP or even whether You pass the binary data into Your select - where query… Just guessing due to the php tag…

More Related Contents:

  1. PHP PDO and Mysql [closed]
  2. Parse error: syntax error, unexpected T_STRING in C:\wamp\www\b_php\project\login_save.php on line 14 [closed]
  3. The requested URL was not found on this server.
  4. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  5. How to create a secure mysql prepared statement in php?
  6. strange character encoding of stored data , old script is showing them fine new one doesn’t
  7. Doctrine 2 and Many-to-many link table with an extra field
  8. Post form and update multiple rows with mysql
  9. MySQL/PHP Error:[2002] Only one usage of each socket address (protocol/network address/port) is normally permitted
  10. How to use multiple databases dynamically for one model in CakePHP
  11. How to install pdo driver in php docker image?
  12. Calculating distance between zip codes in PHP
  13. MySQL retrieve variable from Stored Procedure in PHP PDO
  14. Can’t insert Chinese character into MySQL
  15. Send data from android to server via JSON
  16. #1193 – Unknown system variable ‘lc_messages’ when trying to login to phpmyadmin
  17. Laravel 5.5 Error Base table or view already exists: 1050 Table ‘users’ already exists
  18. Error while using PDO prepared statements and LIMIT in query [duplicate]
  19. PDO prepared statement fetch() returning double results
  20. SQLSTATE[HY093]: Invalid parameter number: parameter was not defined
  21. How to SELECT DEFAULT value of a field
  22. Laravel SQLSTATE[HY000] [2002] Connection refused
  23. Selecting all fields except only one field in mysql [duplicate]
  24. how to download blob based file from MySQL database in PHP?
  25. How to specify the parent query field from within a subquery in MySQL?
  26. CONCAT columns with Laravel 5 eloquent
  27. UNION syntax in Cakephp
  28. How do i search from serialize field in mysql database?
  29. What is the PDO equivalent of function mysql_real_escape_string?
  30. Installing PDO driver on MySQL Linux server

Leave a Comment