SQL: String that contains 1, 2,3,4 or 5 characters

Question

I need to get data from database, that has a table called "our_videos", and a column called "champion" must contain a data with string that have character $. My current SQL code looks like this:

SELECT * FROM our_videos WHERE champion LIKE '%$%'

but it gives me data that looks like this: .....$.....$....$....$... but I only want a data that looks like this .....$..... Sorry if there are not enough needed data, just ask and I'll add if required.

Here as asked some sample data:

Table:

id|champion

54|"Something$Something"

55|"Something$Something$something"

56|"Something$Something$Something$something"

57|"Something"

With SQL command that I wrote I'd get rows with ID 54,55,56 but I want to get only row with id 54

Your question is not clear. Can you add sample data? – Jens Feb 14 '15 at 14:31 — Jens, Feb 14 '15 at 14:31
Updated with some sample data – Donny123 Feb 14 '15 at 14:35 — Donny123, Feb 14 '15 at 14:35

score 8 · Answer 1 · answered Feb 14 '15 at 14:36

8

You need a single $?

SELECT * 
FROM our_videos 
WHERE champion LIKE '%$%'
  AND champion NOT LIKE '%$%$%'

answered Feb 14 '15 at 14:36

dnoeth

59,503
4
39
56

Okay I'll test it in a couple of minutes and accept if everything will work – Donny123 Feb 14 '15 at 14:37

score 0 · Accepted Answer · edited May 23 '17 at 12:07

0

Maybe should you indicate the number of occurrences of $ you're looking for... Like in this so answer.

edited May 23 '17 at 12:07

Community

1
1

answered Feb 14 '15 at 14:39

JBA

2,889
1
21
38

SQL: String that contains 1, 2,3,4 or 5 characters

2 Answers2