0

I am trying to do a replace on the following string where the last five digits are different in each row- Stipends I understand that I should be able to do this with Regex replace but am struggling to get it written correctly to pull the rows I need to work on...I believe there is a hidden space at the beginning of the second row. Would appreciate any help - I have to include the first row so that it does not replace another url in the same field that is similarly named. I have been trying to just see if I can pull the rows I need with a Select query but pull nothing once I get past the first row of the string...is there a way to escape the whole string up to the equals sign?

I have been trying to just see if I can pull the rows I need with a Select query but pull nothing once I get past the first row of the string. Any additonal characters just pull zero rows.

Improve this question
3
  • 2
    I removed the mysql tag. MariaDB and MySQL are different products, and a solution for one may not be applicable to the other. It would help if you specify exactly the version of MariaDB you use, because this may also affect the solution. Query SELECT VERSION(); to get this information. Commented Oct 15, 2024 at 23:24
  • 1
    Read carefully: Tips for asking a good Structured Query Language (SQL) question. Especially #5 and #3. Commented Oct 16, 2024 at 5:02
  • Please provide an example of the data. And use SELECT HEX(col) ... so we can see any strange bytes. It might be hex A0 from MS Word -- a special blank. Also provide SHOW CREATE TABLE so we can see what CHARACTER SET and COLLATION is on the column. Commented Oct 16, 2024 at 18:16
Related questions
0
Mariadb query variable with null value returns nothing
0
mysql: retrieve all rows using common table expression
0
MariaDB COLUMN_JSON query returns binary
Load 5 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.