How we include double space in SQL squery

Question

1.00/5 (2 votes)

See more:

in sql i use select the query using some condition value have new line space or double space

in that i did not got any result

What I have tried:

**Example:

SQL

select name from username where name like '% senr lim mintu%'

if i give like this:

SQL

select name from username where name like '% senr %'

i got result

customer have gave like new line or double space as before i try**

Posted 9-May-24 21:03pm

senthilnathan p

Updated 10-May-24 7:42am

Maciej Los

v2

Add a Solution

Comments

Richard Deeming 10-May-24 3:28am

Your question is not clear.

If your first query doesn't return any results, that means there are no records in your table which match the condition you're searching for.

We cannot access your database, so we have no idea what the data actually looks like, and we can't tell you how to fix your query.

CHill60 10-May-24 3:58am

You should validate user input before storing it on your database to prevent stuff like this from happening.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2024-05-09T22:06:00

The SQL LIKE condition is pretty basic: it doesn't support regular expressions without managed code (which is it's own can of worms).
All you get are character ('[' followed by a character list then ']'), not a character ('[^' followed by a character list then ']'), match any character ('_') and match any number of characters ('%')

You want to match optional double spaces and so forth, you need to either invest time in learning SQL managed code[^], change how you store data, or do the work in your presentation language instead of SQL.