sql query to search string has special characters using mysql

133
January 15, 2022, at 04:30 AM

I would like to know how to write sql query for search string that has special characters

I have table dlist with columns postalcode, block and floor and want to search like postalcode #block-floor pattern

Below is the search string type pattern I use

380100 #06-764 , 380100 06-764, 380100 6-764,
#06-764 380100 , 06-764 380100, 6-764 380100

Below is table and query tried

id block floor postalcode
1  6    764     380100
2  90    123     123456
3  2     457     456567
SELECT * FROM dlist WHERE 
CONCAT(postalcode, ' ',block,'-',floor) LIKE
'%380100 #06-764%';
Rent Charter Buses Company
READ ALSO
I Want to Create a Cached Version of a Website in Nginx

I Want to Create a Cached Version of a Website in Nginx

I have a website A whose content gets updated every minute(Its content is related to stock price)However, because displaying the content of website A requires expensive computation, I want to create a website B that shows a cached version of the website...

68
How to setup a bulk action in the woocommerce order list

How to setup a bulk action in the woocommerce order list

I am working on some new code for my website but sadly I hit a roadblockUsing the following question I was able to setup some code in preparation for my other functionalities

142
Spring webclient is not logging error response and performing consumer action on receiving error

Spring webclient is not logging error response and performing consumer action on receiving error

I have a spring boot service where APIs are exposed via RouterFunctionOnce the API request is received , certain validations are triggered

130
How to make a website that makes websites [closed]

How to make a website that makes websites [closed]

Want to improve this question? Update the question so it focuses on one problem only by editing this post

128