python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - sql-like

Declaring Variables, LIKE and booleans

Can "LIKE" and a boolean behave the same way in a variable (IN SQL)? Or is there a way to do this? I'm trying to declare a variable and have that variable be brought into my WHERE and everyw...
test-img

supeercod

sql

variables

boolean

sql-like

Votes: 0

Answers: 1

Latest Answer

You can't do what you're trying to do. The variable is only a VARCHAR. It can't include logic. This accomplishes the same thing, but the logic needs to be in the statements, not in the variable. DECL...
test-img

Steven Ensslen

Performance tuning AWS Athena alternative query to using LIKE function

I'm querying 20GB of domain data with AWS Athena. I'm trying to get all IP values that match a domain. My query goes like this: SELECT ip_value FROM domains WHERE domain_name LIKE '%<some_domain>...
test-img

M. Phys

amazon-web-services

query-optimization

sql-like

amazon-athena

presto

Votes: 0

Answers: 0

Selecting an unknown variable from a database using LIKE

I have created a search bar that searches for a specific key word in each paragraph on the page. Each paragraph has its own column in the table. When it searches the database I can't seem to select th...
test-img

Visbot-2187

mysql

sql-like

Votes: 0

Answers: 1

Latest Answer

You can use IF to check each column and return it if it matches. SELECT IF(title LIKE '%$search%', title, NULL) AS title, IF(paraOne LIKE '%$search%', paraOne, NULL) AS paraOne, IF(paraTw...
test-img

Barmar

sql query to search string has special characters using mysql

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 pa...
test-img

sen

mysql

select

replace

where-clause

sql-like

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs