SQL syntax issue

Databases
#1

This is OT for XOJO, my apologies, but I’ve helped plenty… =)

I’m not familiar with SQL but I need to make a range edit in phpMyAdmin. For a single deletion of a post in this database, this works and looks like this:

DELETE FROM chickens_pbb02.posts WHERE posts.post_time = 1472310211;

I try a range, and guessing this:

DELETE FROM chickens_pbb02.posts WHERE posts.post_time BETWEEN 1470854475 AND 1472310211;

I get a syntax error. Where am I going wrong?

#2

@Garth Hjelle: Does this work?

DELETE FROM chickens_pbb02.posts WHERE posts.post_time >= 1470854475 AND posts.post_time <=1472310211;

#3

What is column type of posts.post_time? What is the syntax error you get?

#4

I do want to ask, why doesn’t BETWEEN work? I googled and that’s what it said to do.

#5

What version of mySQL are you using ?

#6