Welcome Guest, Not a member yet? Register   Sign In
How to remove the first word From Mysql Table?
#8

(This post was last modified: 05-08-2021, 09:30 AM by nfaiz.)

Like this SQL?

Code:
UPDATE items SET
Coupon_codes = SUBSTRING(Coupon_codes, LOCATE(' ', Coupon_codes)+1)
--WHERE id = :id:
Reply


Messages In This Thread
RE: How to remove the first word From Mysql Table? - by nfaiz - 05-08-2021, 09:29 AM



Theme © iAndrew 2016 - Forum software by © MyBB