Multi tool use

MySQL special characters effect search result [on hold]

I have a record like this:

214/13rr3323

i use this query

... WHERE c.name LIKE ?
... $etc->execute(array("%".$this->word."%");


stops searching after "/" character. Why does this happen?

I want to search like this

21413rr3323

but without "/" character, I got no results.

thanks anyway

i need a sql query that NOT ALLOWS characters except /[^a-zA-Z0-9]/

SELECT product.size FROM product.size WHERE replace(product.size, '/', '')
LIKE ?


How can i do multiple replace ?

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

2 Answers
2

You can apply search by first character and last character of string like this query

$query = "SELECT * FROM `table_name` WHERE search_field like '%last_charcter_of_string' and search_field like 'first_charcter_of_string%'";


first you have to get first and last chracter of string using substr function then apply in this query

This may seem like a really jank method to fix this, but I'd try doing something along the lines of:

$fullString = "214/13rr3323"; //whatever your original search was

$split = explode("/", $fullString);


Then whenever you do your query, puzzle it back together with something like:

$etc->execute(array("%" . $split[0] . "/" . $split[1] . "%");


You could try a different method of escaping aswell, such as preg_replace.

Sorry if this answer seems not as detailed as it should, but you didn't give a whole lot to work with.

Regardless, hope this helps! Good luck to you!

21413rr3323

214/13rr3323

21413rr3323